package com.janj.dao;

import com.janj.bean.Student;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface StudentMapper {

         @Select("SELECT * FROM student WHERE gradeid = #{gradeid}")
       public abstract List<Student> selectStudentByGradeid(Integer gradeid);

          @Select("SELECT * FROM student t1 ,middle t2 WHERE t1.sid = t2.msid AND t2.mcid = #{cid}")
         public abstract List<Student> selectStudentByCid(Integer cid);

}
